---
title: SAIF.Business.View.Provider SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-08-21
library: SAIF.Business.View.Provider
reference_type: embedded
---

# SAIF.Business.View.Provider SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.
The library is read-only: every `CreateSQL`, `InsertSQL`, `UpdateSQL`, and `DeleteSQL` property
throws `ApplicationException`, so only Read (SELECT) statements exist and no sequences are used.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-DCBS-01](SQL-DCBS-01-dcbs-cost-charges.md) | Retrieve DCBS cost-charge factors for a provider location | StringBuilder-assembled | PROVIDER_DCBS_COST_CHARGE | `clsDCBSCostChargeList` |
| [SQL-MCO-01](SQL-MCO-01-mco-provider-plans.md) | Retrieve MCO plan enrollments for a provider location | StringBuilder-assembled | MCO_PROVIDER | `clsMCOProviderList` |
| [SQL-PRV-01](SQL-PRV-01-provider-by-id.md) | Retrieve a single provider by its surrogate ID | Inline | PROVIDER, PROVIDER_TAX_ID | `clsProvider` |
| [SQL-PRV-01b](SQL-PRV-01b-provider-by-tax-id.md) | Retrieve a single provider by its primary tax ID | Inline | PROVIDER, PROVIDER_TAX_ID | `clsProvider` |
| [SQL-PADR-01](SQL-PADR-01-provider-addresses.md) | Retrieve formatted mailing address details for a provider location | Inline | PROVIDER_LOCATION, PROVIDER_ADDRESS | `clsProviderAddressCollection` |
| [SQL-PRV-02](SQL-PRV-02-provider-collection-by-taxid.md) | Retrieve multiple providers matching a tax-ID list | Inline (concatenated) | PROVIDER, PROVIDER_TAX_ID | `clsProviderCollection` |
| [SQL-PRV-02b](SQL-PRV-02b-provider-collection-by-where.md) | Retrieve providers using a caller-supplied WHERE predicate | Inline (concatenated) | PROVIDER, PROVIDER_TAX_ID | `clsProviderCollection` |
| [SQL-PINE-01](SQL-PINE-01-ineligibility-period-by-id.md) | Retrieve a single provider ineligibility period by ID | Inline | PROVIDER_INELIG_PERIOD | `clsProviderIneligibilityPeriod` |
| [SQL-PINE-02](SQL-PINE-02-ineligibility-periods-by-location.md) | Retrieve all ineligibility periods for a provider location | Inline | PROVIDER_INELIG_PERIOD | `clsProviderIneligibilityPeriodCollection` |
| [SQL-PLOC-01](SQL-PLOC-01-provider-location-by-id.md) | Retrieve a single provider location by its surrogate ID | Inline | PROVIDER_LOCATION | `clsProviderLocation` |
| [SQL-PLOC-02](SQL-PLOC-02-locations-by-provider.md) | Retrieve all locations for a given provider | Inline | PROVIDER_LOCATION | `clsProviderLocationCollection` |
| [SQL-PLOC-03](SQL-PLOC-03-locations-by-type.md) | Retrieve all locations having a given provider type code | Inline | PROVIDER_LOCATION | `clsProviderLocationCollection` |
| [SQL-PREL-01](SQL-PREL-01-child-relationships.md) | Retrieve child provider locations related to a parent location | Inline | PROVIDER_LOCATION, PROVIDER_RELATIONSHIP | `clsProviderRelationshipCollection` |
| [SQL-PREL-02](SQL-PREL-02-parent-relationships.md) | Retrieve parent provider locations related to a child location | Inline | PROVIDER_LOCATION, PROVIDER_RELATIONSHIP | `clsProviderRelationshipCollection` |
| [SQL-SRCH-01](SQL-SRCH-01-provider-search.md) | Search provider locations by name, address, tax ID, and other optional criteria | StringBuilder-assembled | PROVIDER_LOCATION, PROVIDER_TYPE_CODE, PROVIDER_ADDRESS, PROVIDER_TAX_ID, PROVIDER_IDENTITY, PROVIDER_SERVICE, MCO_PROVIDER | N/A (Application layer) |
| [SQL-PSVC-02](SQL-PSVC-02-provider-service-contracts.md) | Retrieve service contracts for a provider location within an optional date window | StringBuilder-assembled | PROVIDER_SERVICE_CONTRACT | N/A (Application layer) |
| [SQL-PSVC-01](SQL-PSVC-01-provider-services.md) | Retrieve service codes and descriptions offered by a provider location | StringBuilder-assembled | PROVIDER_SERVICE_CODE, PROVIDER_SERVICE | N/A (Application layer) |
| [SQL-PTAX-01](SQL-PTAX-01-provider-tax-ids.md) | Retrieve all tax ID records for a provider | Inline | PROVIDER_TAX_ID | `clsProviderTaxIDCollection` |
| [SQL-PTYP-01](SQL-PTYP-01-provider-type-by-code.md) | Retrieve a single provider type definition by its code | Inline | PROVIDER_TYPE_CODE | `clsProviderType` |
| [SQL-PTYP-02](SQL-PTYP-02-all-provider-types.md) | Retrieve the full list of provider type definitions, sorted by description | Inline | PROVIDER_TYPE_CODE | `clsProviderTypeCollection` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- SAIF.Business.View.Provider/clsDCBSCostCharge.vb
- SAIF.Business.View.Provider/clsMCOProvider.vb
- SAIF.Business.View.Provider/clsProvider.vb
- SAIF.Business.View.Provider/clsProviderAddress.vb
- SAIF.Business.View.Provider/clsProviderAddressCollection.vb
- SAIF.Business.View.Provider/clsProviderCollection.vb
- SAIF.Business.View.Provider/clsProviderIneligibilityPeriod.vb
- SAIF.Business.View.Provider/clsProviderIneligibilityPeriodCollection.vb
- SAIF.Business.View.Provider/clsProviderLocation.vb
- SAIF.Business.View.Provider/clsProviderLocationCollection.vb
- SAIF.Business.View.Provider/clsProviderRelationshipCollection.vb
- SAIF.Business.View.Provider/clsProviderSearch.vb
- SAIF.Business.View.Provider/clsProviderServiceContract.vb
- SAIF.Business.View.Provider/clsProviderServices.vb
- SAIF.Business.View.Provider/clsProviderTaxIDCollection.vb
- SAIF.Business.View.Provider/clsProviderType.vb
- SAIF.Business.View.Provider/clsProviderTypeCollection.vb